﻿
create database Blogs
use Blogs
go
create table Users
(id int primary key identity(1,1),
Username nvarchar(20) not null,
Password nvarchar(30) not null
)

create table Articles
(
id int primary key identity(1,1),
Title nvarchar(50) not null,
Author nvarchar(50) not null,
CreatedTime datetime default getdate() 
)
go
insert into Users(Username,Password) values('admin','123')

insert into Articles(Title,Author) values
('三国','本人'),
('红楼梦','林黛玉'),
('西游记','唐僧'),
('水浒传','浪里小白条')
